{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": false }, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/Users/admin/anaconda/envs/python3.6/lib/python3.6/site-packages/IPython/core/interactiveshell.py:2862: FutureWarning: \n", "mpl_style had been deprecated and will be removed in a future version.\n", "Use `matplotlib.pyplot.style.use` instead.\n", "\n", " exec(code_obj, self.user_global_ns, self.user_ns)\n" ] } ], "source": [ "# The usual preamble\n", "%matplotlib inline\n", "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "\n", "# Make the graphs a bit prettier, and bigger\n", "pd.set_option('display.mpl_style', 'default')\n", "\n", "# This is necessary to show lots of columns in pandas 0.12. \n", "# Not necessary in pandas 0.13.\n", "pd.set_option('display.width', 5000) \n", "pd.set_option('display.max_columns', 60)\n", "\n", "plt.rcParams['figure.figsize'] = (15, 5)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "We're going to use a new dataset here, to demonstrate how to deal with larger datasets. This is a subset of the of 311 service requests from [NYC Open Data](https://nycopendata.socrata.com/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9). " ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/Users/admin/anaconda/envs/python3.6/lib/python3.6/site-packages/IPython/core/interactiveshell.py:2698: DtypeWarning: Columns (8) have mixed types. Specify dtype option on import or set low_memory=False.\n", " interactivity=interactivity, compiler=compiler, result=result)\n" ] } ], "source": [ "complaints = pd.read_csv('../data/311-service-requests.csv')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Depending on your pandas version, you might see an error like \"DtypeWarning: Columns (8) have mixed types\". This means that it's encountered a problem reading in our data. In this case it almost certainly means that it has columns where some of the entries are strings and some are integers.\n", "\n", "For now we're going to ignore it and hope we don't run into a problem, but in the long run we'd need to investigate this warning." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# 2.1 What's even in it? (the summary)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "When you print a large dataframe, it will only show you the first few rows.\n", "\n", "If you don't see this, don't panic! The default behavior for large dataframes changed between pandas 0.12 and 0.13. Previous to 0.13 it would show you a summary of the dataframe. This includes all the columns, and how many non-null values there are in each column." ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | Unique Key | \n", "Created Date | \n", "Closed Date | \n", "Agency | \n", "Agency Name | \n", "Complaint Type | \n", "Descriptor | \n", "Location Type | \n", "Incident Zip | \n", "Incident Address | \n", "Street Name | \n", "Cross Street 1 | \n", "Cross Street 2 | \n", "Intersection Street 1 | \n", "Intersection Street 2 | \n", "Address Type | \n", "City | \n", "Landmark | \n", "Facility Type | \n", "Status | \n", "Due Date | \n", "Resolution Action Updated Date | \n", "Community Board | \n", "Borough | \n", "X Coordinate (State Plane) | \n", "Y Coordinate (State Plane) | \n", "Park Facility Name | \n", "Park Borough | \n", "School Name | \n", "School Number | \n", "School Region | \n", "School Code | \n", "School Phone Number | \n", "School Address | \n", "School City | \n", "School State | \n", "School Zip | \n", "School Not Found | \n", "School or Citywide Complaint | \n", "Vehicle Type | \n", "Taxi Company Borough | \n", "Taxi Pick Up Location | \n", "Bridge Highway Name | \n", "Bridge Highway Direction | \n", "Road Ramp | \n", "Bridge Highway Segment | \n", "Garage Lot Name | \n", "Ferry Direction | \n", "Ferry Terminal Name | \n", "Latitude | \n", "Longitude | \n", "Location | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "26589651 | \n", "10/31/2013 02:08:41 AM | \n", "NaN | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Street/Sidewalk | \n", "Loud Talking | \n", "Street/Sidewalk | \n", "11432 | \n", "90-03 169 STREET | \n", "169 STREET | \n", "90 AVENUE | \n", "91 AVENUE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "JAMAICA | \n", "NaN | \n", "Precinct | \n", "Assigned | \n", "10/31/2013 10:08:41 AM | \n", "10/31/2013 02:35:17 AM | \n", "12 QUEENS | \n", "QUEENS | \n", "1042027.0 | \n", "197389.0 | \n", "Unspecified | \n", "QUEENS | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.708275 | \n", "-73.791604 | \n", "(40.70827532593202, -73.79160395779721) | \n", "
1 | \n", "26593698 | \n", "10/31/2013 02:01:04 AM | \n", "NaN | \n", "NYPD | \n", "New York City Police Department | \n", "Illegal Parking | \n", "Commercial Overnight Parking | \n", "Street/Sidewalk | \n", "11378 | \n", "58 AVENUE | \n", "58 AVENUE | \n", "58 PLACE | \n", "59 STREET | \n", "NaN | \n", "NaN | \n", "BLOCKFACE | \n", "MASPETH | \n", "NaN | \n", "Precinct | \n", "Open | \n", "10/31/2013 10:01:04 AM | \n", "NaN | \n", "05 QUEENS | \n", "QUEENS | \n", "1009349.0 | \n", "201984.0 | \n", "Unspecified | \n", "QUEENS | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.721041 | \n", "-73.909453 | \n", "(40.721040535628305, -73.90945306791765) | \n", "
2 | \n", "26594139 | \n", "10/31/2013 02:00:24 AM | \n", "10/31/2013 02:40:32 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Commercial | \n", "Loud Music/Party | \n", "Club/Bar/Restaurant | \n", "10032 | \n", "4060 BROADWAY | \n", "BROADWAY | \n", "WEST 171 STREET | \n", "WEST 172 STREET | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 10:00:24 AM | \n", "10/31/2013 02:39:42 AM | \n", "12 MANHATTAN | \n", "MANHATTAN | \n", "1001088.0 | \n", "246531.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.843330 | \n", "-73.939144 | \n", "(40.84332975466513, -73.93914371913482) | \n", "
3 | \n", "26595721 | \n", "10/31/2013 01:56:23 AM | \n", "10/31/2013 02:21:48 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Vehicle | \n", "Car/Truck Horn | \n", "Street/Sidewalk | \n", "10023 | \n", "WEST 72 STREET | \n", "WEST 72 STREET | \n", "COLUMBUS AVENUE | \n", "AMSTERDAM AVENUE | \n", "NaN | \n", "NaN | \n", "BLOCKFACE | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 09:56:23 AM | \n", "10/31/2013 02:21:10 AM | \n", "07 MANHATTAN | \n", "MANHATTAN | \n", "989730.0 | \n", "222727.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.778009 | \n", "-73.980213 | \n", "(40.7780087446372, -73.98021349023975) | \n", "
4 | \n", "26590930 | \n", "10/31/2013 01:53:44 AM | \n", "NaN | \n", "DOHMH | \n", "Department of Health and Mental Hygiene | \n", "Rodent | \n", "Condition Attracting Rodents | \n", "Vacant Lot | \n", "10027 | \n", "WEST 124 STREET | \n", "WEST 124 STREET | \n", "LENOX AVENUE | \n", "ADAM CLAYTON POWELL JR BOULEVARD | \n", "NaN | \n", "NaN | \n", "BLOCKFACE | \n", "NEW YORK | \n", "NaN | \n", "NaN | \n", "Pending | \n", "11/30/2013 01:53:44 AM | \n", "10/31/2013 01:59:54 AM | \n", "10 MANHATTAN | \n", "MANHATTAN | \n", "998815.0 | \n", "233545.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.807691 | \n", "-73.947387 | \n", "(40.80769092704951, -73.94738703491433) | \n", "
5 | \n", "26592370 | \n", "10/31/2013 01:46:52 AM | \n", "NaN | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Commercial | \n", "Banging/Pounding | \n", "Club/Bar/Restaurant | \n", "11372 | \n", "37 AVENUE | \n", "37 AVENUE | \n", "84 STREET | \n", "85 STREET | \n", "NaN | \n", "NaN | \n", "BLOCKFACE | \n", "JACKSON HEIGHTS | \n", "NaN | \n", "Precinct | \n", "Open | \n", "10/31/2013 09:46:52 AM | \n", "NaN | \n", "03 QUEENS | \n", "QUEENS | \n", "1016948.0 | \n", "212540.0 | \n", "Unspecified | \n", "QUEENS | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.749989 | \n", "-73.881988 | \n", "(40.7499893014072, -73.88198770727831) | \n", "
6 | \n", "26595682 | \n", "10/31/2013 01:46:40 AM | \n", "NaN | \n", "NYPD | \n", "New York City Police Department | \n", "Blocked Driveway | \n", "No Access | \n", "Street/Sidewalk | \n", "11419 | \n", "107-50 109 STREET | \n", "109 STREET | \n", "107 AVENUE | \n", "109 AVENUE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "SOUTH RICHMOND HILL | \n", "NaN | \n", "Precinct | \n", "Assigned | \n", "10/31/2013 09:46:40 AM | \n", "10/31/2013 01:59:51 AM | \n", "10 QUEENS | \n", "QUEENS | \n", "1030919.0 | \n", "187622.0 | \n", "Unspecified | \n", "QUEENS | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.681533 | \n", "-73.831737 | \n", "(40.68153278675525, -73.83173699701601) | \n", "
7 | \n", "26595195 | \n", "10/31/2013 01:44:19 AM | \n", "10/31/2013 01:58:49 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Commercial | \n", "Loud Music/Party | \n", "Club/Bar/Restaurant | \n", "11417 | \n", "137-09 CROSSBAY BOULEVARD | \n", "CROSSBAY BOULEVARD | \n", "PITKIN AVENUE | \n", "VAN WICKLEN ROAD | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "OZONE PARK | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 09:44:19 AM | \n", "10/31/2013 01:58:49 AM | \n", "10 QUEENS | \n", "QUEENS | \n", "1027776.0 | \n", "184076.0 | \n", "Unspecified | \n", "QUEENS | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.671816 | \n", "-73.843092 | \n", "(40.67181584567338, -73.84309181950769) | \n", "
8 | \n", "26590540 | \n", "10/31/2013 01:44:14 AM | \n", "10/31/2013 02:28:04 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Commercial | \n", "Loud Talking | \n", "Club/Bar/Restaurant | \n", "10011 | \n", "258 WEST 15 STREET | \n", "WEST 15 STREET | \n", "7 AVENUE | \n", "8 AVENUE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 09:44:14 AM | \n", "10/31/2013 02:00:56 AM | \n", "04 MANHATTAN | \n", "MANHATTAN | \n", "984031.0 | \n", "208847.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.739913 | \n", "-74.000790 | \n", "(40.73991339303542, -74.00079028612932) | \n", "
9 | \n", "26594392 | \n", "10/31/2013 01:34:41 AM | \n", "10/31/2013 02:23:51 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Commercial | \n", "Loud Music/Party | \n", "Club/Bar/Restaurant | \n", "11225 | \n", "835 NOSTRAND AVENUE | \n", "NOSTRAND AVENUE | \n", "UNION STREET | \n", "PRESIDENT STREET | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "BROOKLYN | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 09:34:41 AM | \n", "10/31/2013 01:48:26 AM | \n", "09 BROOKLYN | \n", "BROOKLYN | \n", "997941.0 | \n", "182725.0 | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.668204 | \n", "-73.950648 | \n", "(40.66820406598287, -73.95064760056546) | \n", "
10 | \n", "26595176 | \n", "10/31/2013 01:25:12 AM | \n", "NaN | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - House of Worship | \n", "Loud Music/Party | \n", "House of Worship | \n", "11218 | \n", "3775 18 AVENUE | \n", "18 AVENUE | \n", "EAST 9 STREET | \n", "EAST 8 STREET | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "BROOKLYN | \n", "NaN | \n", "Precinct | \n", "Open | \n", "10/31/2013 09:25:12 AM | \n", "NaN | \n", "14 BROOKLYN | \n", "BROOKLYN | \n", "992726.0 | \n", "170399.0 | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.634378 | \n", "-73.969462 | \n", "(40.63437840816299, -73.96946177104543) | \n", "
11 | \n", "26591982 | \n", "10/31/2013 01:24:14 AM | \n", "10/31/2013 01:54:39 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Commercial | \n", "Loud Music/Party | \n", "Club/Bar/Restaurant | \n", "10003 | \n", "187 2 AVENUE | \n", "2 AVENUE | \n", "EAST 11 STREET | \n", "EAST 12 STREET | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 09:24:14 AM | \n", "10/31/2013 01:54:39 AM | \n", "03 MANHATTAN | \n", "MANHATTAN | \n", "988110.0 | \n", "205533.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.730816 | \n", "-73.986073 | \n", "(40.73081644089586, -73.98607265739876) | \n", "
12 | \n", "26594169 | \n", "10/31/2013 01:20:57 AM | \n", "10/31/2013 02:12:31 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Illegal Parking | \n", "Double Parked Blocking Vehicle | \n", "Street/Sidewalk | \n", "10029 | \n", "65 EAST 99 STREET | \n", "EAST 99 STREET | \n", "MADISON AVENUE | \n", "PARK AVENUE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 09:20:57 AM | \n", "10/31/2013 01:42:05 AM | \n", "11 MANHATTAN | \n", "MANHATTAN | \n", "997470.0 | \n", "226725.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.788974 | \n", "-73.952259 | \n", "(40.78897400211689, -73.95225898702977) | \n", "
13 | \n", "26594391 | \n", "10/31/2013 01:20:13 AM | \n", "NaN | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Vehicle | \n", "Engine Idling | \n", "Street/Sidewalk | \n", "10466 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "STRANG AVENUE | \n", "AMUNDSON AVENUE | \n", "INTERSECTION | \n", "BRONX | \n", "NaN | \n", "Precinct | \n", "Open | \n", "10/31/2013 09:20:13 AM | \n", "NaN | \n", "12 BRONX | \n", "BRONX | \n", "1029467.0 | \n", "264124.0 | \n", "Unspecified | \n", "BRONX | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.891517 | \n", "-73.836457 | \n", "(40.89151738488846, -73.83645714593568) | \n", "
14 | \n", "26590917 | \n", "10/31/2013 01:19:54 AM | \n", "NaN | \n", "DOHMH | \n", "Department of Health and Mental Hygiene | \n", "Rodent | \n", "Rat Sighting | \n", "1-2 Family Mixed Use Building | \n", "11219 | \n", "63 STREET | \n", "63 STREET | \n", "13 AVENUE | \n", "14 AVENUE | \n", "NaN | \n", "NaN | \n", "BLOCKFACE | \n", "BROOKLYN | \n", "NaN | \n", "NaN | \n", "Pending | \n", "11/30/2013 01:19:54 AM | \n", "10/31/2013 01:29:26 AM | \n", "10 BROOKLYN | \n", "BROOKLYN | \n", "984467.0 | \n", "167519.0 | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.626477 | \n", "-73.999218 | \n", "(40.6264774690411, -73.99921826202639) | \n", "
15 | \n", "26591458 | \n", "10/31/2013 01:14:02 AM | \n", "10/31/2013 01:30:34 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - House of Worship | \n", "Loud Music/Party | \n", "House of Worship | \n", "10025 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "WEST 99 STREET | \n", "BROADWAY | \n", "INTERSECTION | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 09:14:02 AM | \n", "10/31/2013 01:30:34 AM | \n", "07 MANHATTAN | \n", "MANHATTAN | \n", "992454.0 | \n", "229500.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.796597 | \n", "-73.970370 | \n", "(40.7965967075252, -73.97036973473399) | \n", "
16 | \n", "26594086 | \n", "10/31/2013 12:54:03 AM | \n", "10/31/2013 02:16:39 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Street/Sidewalk | \n", "Loud Music/Party | \n", "Street/Sidewalk | \n", "10310 | \n", "173 CAMPBELL AVENUE | \n", "CAMPBELL AVENUE | \n", "HENDERSON AVENUE | \n", "WINEGAR LANE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "STATEN ISLAND | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 08:54:03 AM | \n", "10/31/2013 02:07:14 AM | \n", "01 STATEN ISLAND | \n", "STATEN ISLAND | \n", "952013.0 | \n", "171076.0 | \n", "Unspecified | \n", "STATEN ISLAND | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.636182 | \n", "-74.116150 | \n", "(40.63618202176914, -74.1161500428337) | \n", "
17 | \n", "26595117 | \n", "10/31/2013 12:52:46 AM | \n", "NaN | \n", "NYPD | \n", "New York City Police Department | \n", "Illegal Parking | \n", "Posted Parking Sign Violation | \n", "Street/Sidewalk | \n", "11236 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "ROCKAWAY PARKWAY | \n", "SKIDMORE AVENUE | \n", "INTERSECTION | \n", "BROOKLYN | \n", "NaN | \n", "Precinct | \n", "Open | \n", "10/31/2013 08:52:46 AM | \n", "NaN | \n", "18 BROOKLYN | \n", "BROOKLYN | \n", "1015289.0 | \n", "169710.0 | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.632437 | \n", "-73.888173 | \n", "(40.63243692394328, -73.88817263437012) | \n", "
18 | \n", "26590389 | \n", "10/31/2013 12:51:00 AM | \n", "NaN | \n", "DOT | \n", "Department of Transportation | \n", "Street Light Condition | \n", "Street Light Out | \n", "NaN | \n", "NaN | \n", "226 42 ST E | \n", "42 ST E | \n", "CHURCH AVE | \n", "SNYDER AVE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "NaN | \n", "NaN | \n", "NaN | \n", "Open | \n", "NaN | \n", "NaN | \n", "Unspecified BROOKLYN | \n", "BROOKLYN | \n", "NaN | \n", "NaN | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
19 | \n", "26594210 | \n", "10/31/2013 12:46:27 AM | \n", "NaN | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Commercial | \n", "Loud Music/Party | \n", "Club/Bar/Restaurant | \n", "10033 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "WEST 184 STREET | \n", "BROADWAY | \n", "INTERSECTION | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Assigned | \n", "10/31/2013 08:46:27 AM | \n", "10/31/2013 01:32:41 AM | \n", "12 MANHATTAN | \n", "MANHATTAN | \n", "1002294.0 | \n", "249712.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.852058 | \n", "-73.934776 | \n", "(40.85205827756883, -73.93477640780834) | \n", "
20 | \n", "26592932 | \n", "10/31/2013 12:43:47 AM | \n", "10/31/2013 12:56:20 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - House of Worship | \n", "Loud Music/Party | \n", "House of Worship | \n", "11216 | \n", "778 PARK PLACE | \n", "PARK PLACE | \n", "ROGERS AVENUE | \n", "NOSTRAND AVENUE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "BROOKLYN | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 08:43:47 AM | \n", "10/31/2013 12:56:20 AM | \n", "08 BROOKLYN | \n", "BROOKLYN | \n", "997608.0 | \n", "184656.0 | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.673505 | \n", "-73.951844 | \n", "(40.67350473678714, -73.95184414979961) | \n", "
21 | \n", "26594152 | \n", "10/31/2013 12:41:17 AM | \n", "10/31/2013 01:04:37 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Commercial | \n", "Banging/Pounding | \n", "Store/Commercial | \n", "10016 | \n", "155 E 34TH ST | \n", "E 34TH ST | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "LATLONG | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 08:41:17 AM | \n", "10/31/2013 01:04:38 AM | \n", "06 MANHATTAN | \n", "MANHATTAN | \n", "990133.0 | \n", "211136.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.746194 | \n", "-73.978769 | \n", "(40.74619417253121, -73.97876853124392) | \n", "
22 | \n", "26589678 | \n", "10/31/2013 12:39:55 AM | \n", "NaN | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Vehicle | \n", "Car/Truck Music | \n", "Street/Sidewalk | \n", "11419 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "112 STREET | \n", "ATLANTIC AVENUE | \n", "INTERSECTION | \n", "SOUTH RICHMOND HILL | \n", "NaN | \n", "Precinct | \n", "Open | \n", "10/31/2013 08:39:55 AM | \n", "NaN | \n", "09 QUEENS | \n", "QUEENS | \n", "1030314.0 | \n", "191578.0 | \n", "Unspecified | \n", "QUEENS | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.692394 | \n", "-73.833891 | \n", "(40.69239424979043, -73.8338912453996) | \n", "
23 | \n", "26592304 | \n", "10/31/2013 12:38:00 AM | \n", "NaN | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Commercial | \n", "Loud Music/Party | \n", "Club/Bar/Restaurant | \n", "11216 | \n", "371 TOMPKINS AVENUE | \n", "TOMPKINS AVENUE | \n", "MADISON STREET | \n", "PUTNAM AVENUE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "BROOKLYN | \n", "NaN | \n", "Precinct | \n", "Assigned | \n", "10/31/2013 08:38:00 AM | \n", "10/31/2013 01:16:53 AM | \n", "03 BROOKLYN | \n", "BROOKLYN | \n", "999720.0 | \n", "188825.0 | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.684944 | \n", "-73.944221 | \n", "(40.6849442562592, -73.94422078036632) | \n", "
24 | \n", "26591892 | \n", "10/31/2013 12:37:16 AM | \n", "NaN | \n", "NYPD | \n", "New York City Police Department | \n", "Blocked Driveway | \n", "Partial Access | \n", "Street/Sidewalk | \n", "10305 | \n", "1496 BAY STREET | \n", "BAY STREET | \n", "LYMAN AVENUE | \n", "SCHOOL ROAD | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "STATEN ISLAND | \n", "NaN | \n", "Precinct | \n", "Assigned | \n", "10/31/2013 08:37:16 AM | \n", "10/31/2013 12:52:10 AM | \n", "01 STATEN ISLAND | \n", "STATEN ISLAND | \n", "967283.0 | \n", "160518.0 | \n", "Unspecified | \n", "STATEN ISLAND | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.607245 | \n", "-74.061106 | \n", "(40.60724493456944, -74.06110566015863) | \n", "
25 | \n", "26591573 | \n", "10/31/2013 12:35:18 AM | \n", "10/31/2013 02:41:35 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Street/Sidewalk | \n", "Loud Talking | \n", "Street/Sidewalk | \n", "10312 | \n", "24 PRINCETON LANE | \n", "PRINCETON LANE | \n", "HAMPTON GREEN | \n", "DEAD END | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "STATEN ISLAND | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 08:35:18 AM | \n", "10/31/2013 01:45:17 AM | \n", "03 STATEN ISLAND | \n", "STATEN ISLAND | \n", "929577.0 | \n", "140964.0 | \n", "Unspecified | \n", "STATEN ISLAND | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.553421 | \n", "-74.196743 | \n", "(40.55342078716953, -74.19674315017886) | \n", "
26 | \n", "26590509 | \n", "10/31/2013 12:33:00 AM | \n", "NaN | \n", "DOT | \n", "Department of Transportation | \n", "Street Light Condition | \n", "Street Light Out | \n", "NaN | \n", "NaN | \n", "38 ST E | \n", "38 ST E | \n", "CHURCH AVE | \n", "LINDEN BLVD | \n", "NaN | \n", "NaN | \n", "BLOCKFACE | \n", "NaN | \n", "NaN | \n", "NaN | \n", "Open | \n", "NaN | \n", "NaN | \n", "Unspecified BROOKLYN | \n", "BROOKLYN | \n", "NaN | \n", "NaN | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
27 | \n", "26591379 | \n", "10/31/2013 12:32:44 AM | \n", "NaN | \n", "DOHMH | \n", "Department of Health and Mental Hygiene | \n", "Harboring Bees/Wasps | \n", "Bees/Wasps - Not a beekeper | \n", "3+ Family Mixed Use Building | \n", "10025 | \n", "501 WEST 110 STREET | \n", "WEST 110 STREET | \n", "AMSTERDAM AVENUE | \n", "BROADWAY | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "NEW YORK | \n", "NaN | \n", "NaN | \n", "Open | \n", "11/30/2013 12:32:44 AM | \n", "NaN | \n", "09 MANHATTAN | \n", "MANHATTAN | \n", "994143.0 | \n", "231888.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.803149 | \n", "-73.964266 | \n", "(40.80314938553783, -73.96426608076082) | \n", "
28 | \n", "26594085 | \n", "10/31/2013 12:32:08 AM | \n", "NaN | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Street/Sidewalk | \n", "Loud Talking | \n", "Street/Sidewalk | \n", "10026 | \n", "121 WEST 116 STREET | \n", "WEST 116 STREET | \n", "LENOX AVENUE | \n", "7 AVENUE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Assigned | \n", "10/31/2013 08:32:08 AM | \n", "10/31/2013 02:00:57 AM | \n", "10 MANHATTAN | \n", "MANHATTAN | \n", "997947.0 | \n", "231613.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.802390 | \n", "-73.950526 | \n", "(40.80238950799943, -73.95052644123253) | \n", "
29 | \n", "26589201 | \n", "10/31/2013 12:32:00 AM | \n", "NaN | \n", "DOT | \n", "Department of Transportation | \n", "Street Light Condition | \n", "Street Light Out | \n", "NaN | \n", "10309 | \n", "295 BAYVIEW AVENUE | \n", "BAYVIEW AVENUE | \n", "VAIL AVENUE | \n", "BAYVIEW LANE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "STATEN ISLAND | \n", "NaN | \n", "NaN | \n", "Open | \n", "NaN | \n", "NaN | \n", "03 STATEN ISLAND | \n", "STATEN ISLAND | \n", "927687.0 | \n", "127837.0 | \n", "Unspecified | \n", "STATEN ISLAND | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.517378 | \n", "-74.203435 | \n", "(40.517377871705676, -74.20343466779575) | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
111039 | \n", "26428764 | \n", "10/04/2013 12:17:03 AM | \n", "10/04/2013 12:38:37 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Commercial | \n", "Loud Music/Party | \n", "Club/Bar/Restaurant | \n", "10022 | \n", "249 EAST 53 STREET | \n", "EAST 53 STREET | \n", "3 AVENUE | \n", "2 AVENUE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/04/2013 08:17:03 AM | \n", "10/04/2013 12:38:37 AM | \n", "06 MANHATTAN | \n", "MANHATTAN | \n", "993036.0 | \n", "215164.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.757248 | \n", "-73.968286 | \n", "(40.757247604963055, -73.96828647941395) | \n", "
111040 | \n", "26426166 | \n", "10/04/2013 12:16:22 AM | \n", "10/04/2013 05:50:49 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Commercial | \n", "Loud Music/Party | \n", "Store/Commercial | \n", "10029 | \n", "252 EAST 110 STREET | \n", "EAST 110 STREET | \n", "3 AVENUE | \n", "2 AVENUE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/04/2013 08:16:22 AM | \n", "10/04/2013 05:50:49 AM | \n", "11 MANHATTAN | \n", "MANHATTAN | \n", "1000407.0 | \n", "228425.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.793635 | \n", "-73.941649 | \n", "(40.79363516179995, -73.94164859515777) | \n", "
111041 | \n", "26438565 | \n", "10/04/2013 12:16:00 AM | \n", "NaN | \n", "DEP | \n", "Department of Environmental Protection | \n", "Noise | \n", "Noise: Construction Before/After Hours (NM1) | \n", "NaN | \n", "11231 | \n", "480 VAN BRUNT STREET | \n", "VAN BRUNT STREET | \n", "REED STREET | \n", "DEAD END | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "BROOKLYN | \n", "NaN | \n", "NaN | \n", "Open | \n", "NaN | \n", "NaN | \n", "06 BROOKLYN | \n", "BROOKLYN | \n", "979657.0 | \n", "184924.0 | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.674249 | \n", "-74.016558 | \n", "(40.6742492231181, -74.01655803856313) | \n", "
111042 | \n", "26428990 | \n", "10/04/2013 12:15:52 AM | \n", "10/04/2013 12:44:52 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Street/Sidewalk | \n", "Loud Talking | \n", "Street/Sidewalk | \n", "10014 | \n", "733 WASHINGTON STREET | \n", "WASHINGTON STREET | \n", "BANK STREET | \n", "BETHUNE STREET | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/04/2013 08:15:52 AM | \n", "10/04/2013 12:44:52 AM | \n", "02 MANHATTAN | \n", "MANHATTAN | \n", "981950.0 | \n", "207532.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.736304 | \n", "-74.008299 | \n", "(40.736303747410034, -74.00829935904578) | \n", "
111043 | \n", "26432659 | \n", "10/04/2013 12:15:46 AM | \n", "10/04/2013 04:18:45 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Commercial | \n", "Loud Music/Party | \n", "Club/Bar/Restaurant | \n", "11218 | \n", "1213 CORTELYOU ROAD | \n", "CORTELYOU ROAD | \n", "EAST 12 STREET | \n", "EAST 13 STREET | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "BROOKLYN | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/04/2013 08:15:46 AM | \n", "10/04/2013 04:18:45 AM | \n", "14 BROOKLYN | \n", "BROOKLYN | \n", "993451.0 | \n", "172498.0 | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.640139 | \n", "-73.966847 | \n", "(40.64013899178716, -73.96684680242933) | \n", "
111044 | \n", "26426096 | \n", "10/04/2013 12:14:09 AM | \n", "10/04/2013 01:03:46 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Street/Sidewalk | \n", "Loud Talking | \n", "Street/Sidewalk | \n", "10032 | \n", "539 WEST 162 STREET | \n", "WEST 162 STREET | \n", "ST NICHOLAS AVENUE | \n", "BROADWAY | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/04/2013 08:14:09 AM | \n", "10/04/2013 01:03:46 AM | \n", "12 MANHATTAN | \n", "MANHATTAN | \n", "1000571.0 | \n", "244054.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.836532 | \n", "-73.941018 | \n", "(40.836532082987944, -73.9410182995914) | \n", "
111045 | \n", "26437764 | \n", "10/04/2013 12:14:00 AM | \n", "10/04/2013 12:14:00 AM | \n", "DEP | \n", "Department of Environmental Protection | \n", "Water System | \n", "Dirty Water (WE) | \n", "NaN | \n", "10022 | \n", "251 EAST 51 STREET | \n", "EAST 51 STREET | \n", "3 AVENUE | \n", "2 AVENUE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "NEW YORK | \n", "NaN | \n", "NaN | \n", "Closed | \n", "NaN | \n", "10/04/2013 12:14:00 AM | \n", "06 MANHATTAN | \n", "MANHATTAN | \n", "992791.0 | \n", "214702.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.755980 | \n", "-73.969171 | \n", "(40.75597977288785, -73.96917140638074) | \n", "
111046 | \n", "26436286 | \n", "10/04/2013 12:14:00 AM | \n", "NaN | \n", "DEP | \n", "Department of Environmental Protection | \n", "Noise | \n", "Noise: Construction Before/After Hours (NM1) | \n", "NaN | \n", "11231 | \n", "480 VAN BRUNT STREET | \n", "VAN BRUNT STREET | \n", "REED STREET | \n", "DEAD END | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "BROOKLYN | \n", "NaN | \n", "NaN | \n", "Open | \n", "NaN | \n", "NaN | \n", "06 BROOKLYN | \n", "BROOKLYN | \n", "979657.0 | \n", "184924.0 | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.674249 | \n", "-74.016558 | \n", "(40.6742492231181, -74.01655803856313) | \n", "
111047 | \n", "26428989 | \n", "10/04/2013 12:13:08 AM | \n", "10/04/2013 02:12:47 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Illegal Parking | \n", "Posted Parking Sign Violation | \n", "Street/Sidewalk | \n", "11434 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "GUY R BREWER BOULEVARD | \n", "ROCKAWAY BOULEVARD | \n", "INTERSECTION | \n", "JAMAICA | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/04/2013 08:13:08 AM | \n", "10/04/2013 02:12:47 AM | \n", "13 QUEENS | \n", "QUEENS | \n", "1048801.0 | \n", "178419.0 | \n", "Unspecified | \n", "QUEENS | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.656160 | \n", "-73.767353 | \n", "(40.656160351546845, -73.76735262738222) | \n", "
111048 | \n", "26430030 | \n", "10/04/2013 12:12:07 AM | \n", "10/04/2013 02:45:24 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Street/Sidewalk | \n", "Loud Talking | \n", "Street/Sidewalk | \n", "10027 | \n", "215 WEST 131ST STREET | \n", "WEST 131ST STREET | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "LATLONG | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/04/2013 08:12:07 AM | \n", "10/04/2013 02:45:24 AM | \n", "01 MANHATTAN | \n", "MANHATTAN | \n", "999107.0 | \n", "235603.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.813339 | \n", "-73.946328 | \n", "(40.81333907832113, -73.94632769228208) | \n", "
111049 | \n", "26429663 | \n", "10/04/2013 12:12:07 AM | \n", "10/04/2013 01:03:44 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Commercial | \n", "Loud Music/Party | \n", "Club/Bar/Restaurant | \n", "11209 | \n", "8915 5 AVENUE | \n", "5 AVENUE | \n", "89 STREET | \n", "90 STREET | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "BROOKLYN | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/04/2013 08:12:07 AM | \n", "10/04/2013 01:03:44 AM | \n", "10 BROOKLYN | \n", "BROOKLYN | \n", "976525.0 | \n", "165015.0 | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.619601 | \n", "-74.027826 | \n", "(40.619601147364584, -74.02782628492785) | \n", "
111050 | \n", "26437763 | \n", "10/04/2013 12:11:00 AM | \n", "NaN | \n", "DEP | \n", "Department of Environmental Protection | \n", "Noise | \n", "Noise: Construction Before/After Hours (NM1) | \n", "NaN | \n", "10028 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "EAST 84 STREET | \n", "YORK AVENUE | \n", "INTERSECTION | \n", "NEW YORK | \n", "NaN | \n", "NaN | \n", "Open | \n", "NaN | \n", "NaN | \n", "08 MANHATTAN | \n", "MANHATTAN | \n", "998629.0 | \n", "221493.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.774612 | \n", "-73.948085 | \n", "(40.77461174278734, -73.94808472177321) | \n", "
111051 | \n", "26432955 | \n", "10/04/2013 12:08:15 AM | \n", "10/04/2013 12:48:02 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Commercial | \n", "Loud Music/Party | \n", "Club/Bar/Restaurant | \n", "10009 | \n", "506 EAST 13 STREET | \n", "EAST 13 STREET | \n", "AVENUE A | \n", "AVENUE B | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/04/2013 08:08:15 AM | \n", "10/04/2013 12:48:03 AM | \n", "03 MANHATTAN | \n", "MANHATTAN | \n", "989678.0 | \n", "205065.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.729531 | \n", "-73.980416 | \n", "(40.72953107218499, -73.98041550317102) | \n", "
111052 | \n", "26437035 | \n", "10/04/2013 12:08:00 AM | \n", "10/04/2013 12:13:00 AM | \n", "DEP | \n", "Department of Environmental Protection | \n", "Water System | \n", "Dirty Water (WE) | \n", "NaN | \n", "10022 | \n", "325 EAST 54 STREET | \n", "EAST 54 STREET | \n", "2 AVENUE | \n", "1 AVENUE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "NEW YORK | \n", "NaN | \n", "NaN | \n", "Closed | \n", "NaN | \n", "10/04/2013 12:13:00 AM | \n", "06 MANHATTAN | \n", "MANHATTAN | \n", "993688.0 | \n", "215099.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.757069 | \n", "-73.965933 | \n", "(40.75706852462872, -73.96593314322774) | \n", "
111053 | \n", "26433197 | \n", "10/04/2013 12:08:00 AM | \n", "10/04/2013 12:00:00 PM | \n", "DSNY | \n", "BCC - Queens East | \n", "Derelict Vehicles | \n", "14 Derelict Vehicles | \n", "Street | \n", "11413 | \n", "220-11 145 AVENUE | \n", "145 AVENUE | \n", "221 STREET | \n", "221 STREET | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "Springfield Gardens | \n", "NaN | \n", "DSNY Garage | \n", "Pending | \n", "NaN | \n", "10/04/2013 12:08:00 AM | \n", "13 QUEENS | \n", "QUEENS | \n", "1051511.0 | \n", "181411.0 | \n", "Unspecified | \n", "QUEENS | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.664353 | \n", "-73.757556 | \n", "(40.6643525308449, -73.75755575708348) | \n", "
111054 | \n", "26426060 | \n", "10/04/2013 12:06:39 AM | \n", "10/04/2013 12:31:16 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Street/Sidewalk | \n", "Loud Talking | \n", "Street/Sidewalk | \n", "11224 | \n", "4823 BEACH 48 STREET | \n", "BEACH 48 STREET | \n", "BODY OF WATER | \n", "SURF AVENUE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "BROOKLYN | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/04/2013 08:06:39 AM | \n", "10/04/2013 12:31:16 AM | \n", "13 BROOKLYN | \n", "BROOKLYN | \n", "980859.0 | \n", "149681.0 | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.577515 | \n", "-74.012207 | \n", "(40.57751513866536, -74.01220705163807) | \n", "
111055 | \n", "26430628 | \n", "10/04/2013 12:06:28 AM | \n", "10/04/2013 12:21:39 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Commercial | \n", "Loud Talking | \n", "Club/Bar/Restaurant | \n", "11209 | \n", "7915 3 AVENUE | \n", "3 AVENUE | \n", "79 STREET | \n", "80 STREET | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "BROOKLYN | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/04/2013 08:06:28 AM | \n", "10/04/2013 12:21:39 AM | \n", "10 BROOKLYN | \n", "BROOKLYN | \n", "976189.0 | \n", "168214.0 | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.628381 | \n", "-74.029040 | \n", "(40.62838143294541, -74.02904041333245) | \n", "
111056 | \n", "26431648 | \n", "10/04/2013 12:06:26 AM | \n", "10/23/2013 08:14:52 AM | \n", "DOT | \n", "Department of Transportation | \n", "Street Sign - Missing | \n", "Bus Stop | \n", "Street | \n", "11378 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "54 AVENUE | \n", "43 STREET | \n", "INTERSECTION | \n", "MASPETH | \n", "NaN | \n", "NaN | \n", "Closed | \n", "10/14/2013 09:38:47 AM | \n", "10/23/2013 08:14:52 AM | \n", "02 QUEENS | \n", "QUEENS | \n", "1005171.0 | \n", "206064.0 | \n", "Unspecified | \n", "QUEENS | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.732250 | \n", "-73.924513 | \n", "(40.73225000573841, -73.92451289173367) | \n", "
111057 | \n", "26437034 | \n", "10/04/2013 12:06:00 AM | \n", "NaN | \n", "DEP | \n", "Department of Environmental Protection | \n", "Noise | \n", "Noise: Jack Hammering (NC2) | \n", "NaN | \n", "10036 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "WEST 48 STREET | \n", "BROADWAY | \n", "INTERSECTION | \n", "NEW YORK | \n", "NaN | \n", "NaN | \n", "Open | \n", "NaN | \n", "NaN | \n", "05 MANHATTAN | \n", "MANHATTAN | \n", "988451.0 | \n", "216208.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.760116 | \n", "-73.984836 | \n", "(40.76011648520396, -73.98483562074706) | \n", "
111058 | \n", "26426094 | \n", "10/04/2013 12:05:12 AM | \n", "10/04/2013 01:08:29 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Commercial | \n", "Loud Music/Party | \n", "Club/Bar/Restaurant | \n", "11237 | \n", "211 KNICKERBOCKER AVENUE | \n", "KNICKERBOCKER AVENUE | \n", "JEFFERSON STREET | \n", "TROUTMAN STREET | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "BROOKLYN | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/04/2013 08:05:12 AM | \n", "10/04/2013 01:08:29 AM | \n", "04 BROOKLYN | \n", "BROOKLYN | \n", "1004672.0 | \n", "195540.0 | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.703365 | \n", "-73.926345 | \n", "(40.703365329011284, -73.92634531031759) | \n", "
111059 | \n", "26429040 | \n", "10/04/2013 12:04:52 AM | \n", "10/04/2013 03:01:04 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Street/Sidewalk | \n", "Loud Talking | \n", "Street/Sidewalk | \n", "10003 | \n", "99 2 AVENUE | \n", "2 AVENUE | \n", "EAST 5 STREET | \n", "EAST 6 STREET | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/04/2013 08:04:52 AM | \n", "10/04/2013 03:01:04 AM | \n", "03 MANHATTAN | \n", "MANHATTAN | \n", "987393.0 | \n", "204234.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.727251 | \n", "-73.988660 | \n", "(40.727251287038676, -73.98866028603422) | \n", "
111060 | \n", "26434084 | \n", "10/04/2013 12:04:00 AM | \n", "NaN | \n", "DEP | \n", "Department of Environmental Protection | \n", "Noise | \n", "Noise: Construction Before/After Hours (NM1) | \n", "NaN | \n", "10036 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "8 AVENUE | \n", "WEST 47 STREET | \n", "INTERSECTION | \n", "NEW YORK | \n", "NaN | \n", "NaN | \n", "Open | \n", "NaN | \n", "NaN | \n", "04 MANHATTAN | \n", "MANHATTAN | \n", "987720.0 | \n", "216313.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.760405 | \n", "-73.987474 | \n", "(40.76040500039782, -73.98747426235285) | \n", "
111061 | \n", "26426164 | \n", "10/04/2013 12:03:00 AM | \n", "10/04/2013 02:14:57 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Commercial | \n", "Loud Music/Party | \n", "Club/Bar/Restaurant | \n", "11106 | \n", "30-09 BROADWAY | \n", "BROADWAY | \n", "30 STREET | \n", "31 STREET | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "ASTORIA | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/04/2013 08:03:00 AM | \n", "10/04/2013 02:14:57 AM | \n", "01 QUEENS | \n", "QUEENS | \n", "1004746.0 | \n", "217004.0 | \n", "Unspecified | \n", "QUEENS | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.762279 | \n", "-73.926013 | \n", "(40.762278541098084, -73.92601303458156) | \n", "
111062 | \n", "26439710 | \n", "10/04/2013 12:03:00 AM | \n", "10/04/2013 12:03:00 AM | \n", "DEP | \n", "Department of Environmental Protection | \n", "Water System | \n", "Dirty Water (WE) | \n", "NaN | \n", "10022 | \n", "325 EAST 54 STREET | \n", "EAST 54 STREET | \n", "2 AVENUE | \n", "1 AVENUE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "NEW YORK | \n", "NaN | \n", "NaN | \n", "Closed | \n", "NaN | \n", "10/04/2013 12:03:00 AM | \n", "06 MANHATTAN | \n", "MANHATTAN | \n", "993688.0 | \n", "215099.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.757069 | \n", "-73.965933 | \n", "(40.75706852462872, -73.96593314322774) | \n", "
111063 | \n", "26435569 | \n", "10/04/2013 12:02:00 AM | \n", "10/04/2013 01:10:00 AM | \n", "DEP | \n", "Department of Environmental Protection | \n", "Water System | \n", "Dirty Water (WE) | \n", "NaN | \n", "10022 | \n", "311 EAST 50 STREET | \n", "EAST 50 STREET | \n", "2 AVENUE | \n", "1 AVENUE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "NEW YORK | \n", "NaN | \n", "NaN | \n", "Closed | \n", "NaN | \n", "10/04/2013 01:10:00 AM | \n", "06 MANHATTAN | \n", "MANHATTAN | \n", "993118.0 | \n", "214222.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.754662 | \n", "-73.967992 | \n", "(40.75466197318078, -73.96799173864807) | \n", "
111064 | \n", "26426013 | \n", "10/04/2013 12:01:13 AM | \n", "10/07/2013 04:07:16 PM | \n", "DPR | \n", "Department of Parks and Recreation | \n", "Maintenance or Facility | \n", "Structure - Outdoors | \n", "Park | \n", "11213 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "BROOKLYN | \n", "NaN | \n", "NaN | \n", "Closed | \n", "10/18/2013 12:01:13 AM | \n", "10/07/2013 04:07:16 PM | \n", "08 BROOKLYN | \n", "BROOKLYN | \n", "NaN | \n", "NaN | \n", "Brower Park | \n", "BROOKLYN | \n", "Brower Park | \n", "B012 | \n", "NaN | \n", "NaN | \n", "7189658900 | \n", "Brooklyn, St. Marks, Kingston Avenues, Park Place | \n", "BROOKLYN | \n", "NY | \n", "11213 | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
111065 | \n", "26428083 | \n", "10/04/2013 12:01:05 AM | \n", "10/04/2013 02:13:50 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Illegal Parking | \n", "Posted Parking Sign Violation | \n", "Street/Sidewalk | \n", "11434 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "GUY R BREWER BOULEVARD | \n", "ROCKAWAY BOULEVARD | \n", "INTERSECTION | \n", "JAMAICA | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/04/2013 08:01:05 AM | \n", "10/04/2013 02:13:50 AM | \n", "13 QUEENS | \n", "QUEENS | \n", "1048801.0 | \n", "178419.0 | \n", "Unspecified | \n", "QUEENS | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.656160 | \n", "-73.767353 | \n", "(40.656160351546845, -73.76735262738222) | \n", "
111066 | \n", "26428987 | \n", "10/04/2013 12:00:45 AM | \n", "10/04/2013 01:25:01 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Street/Sidewalk | \n", "Loud Talking | \n", "Street/Sidewalk | \n", "10016 | \n", "344 EAST 28 STREET | \n", "EAST 28 STREET | \n", "MOUNT CARMEL PLACE | \n", "1 AVENUE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/04/2013 08:00:45 AM | \n", "10/04/2013 01:25:01 AM | \n", "06 MANHATTAN | \n", "MANHATTAN | \n", "990637.0 | \n", "208987.0 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.740295 | \n", "-73.976952 | \n", "(40.740295354643706, -73.97695165980414) | \n", "
111067 | \n", "26426115 | \n", "10/04/2013 12:00:28 AM | \n", "10/04/2013 04:17:32 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Commercial | \n", "Loud Talking | \n", "Club/Bar/Restaurant | \n", "11226 | \n", "1233 FLATBUSH AVENUE | \n", "FLATBUSH AVENUE | \n", "AVENUE D | \n", "NEWKIRK AVENUE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "BROOKLYN | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/04/2013 08:00:28 AM | \n", "10/04/2013 04:17:32 AM | \n", "14 BROOKLYN | \n", "BROOKLYN | \n", "996654.0 | \n", "172515.0 | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.640182 | \n", "-73.955306 | \n", "(40.64018174662485, -73.95530566958138) | \n", "
111068 | \n", "26428033 | \n", "10/04/2013 12:00:10 AM | \n", "10/04/2013 01:20:52 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Blocked Driveway | \n", "Partial Access | \n", "Street/Sidewalk | \n", "11236 | \n", "1259 EAST 94 STREET | \n", "EAST 94 STREET | \n", "AVENUE J | \n", "AVENUE K | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "BROOKLYN | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/04/2013 08:00:10 AM | \n", "10/04/2013 01:20:52 AM | \n", "18 BROOKLYN | \n", "BROOKLYN | \n", "1011804.0 | \n", "172470.0 | \n", "Unspecified | \n", "BROOKLYN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.640024 | \n", "-73.900717 | \n", "(40.640024057399216, -73.90071711703163) | \n", "
111069 rows × 52 columns
\n", "\n", " | Unique Key | \n", "Created Date | \n", "Closed Date | \n", "Agency | \n", "Agency Name | \n", "Complaint Type | \n", "Descriptor | \n", "Location Type | \n", "Incident Zip | \n", "Incident Address | \n", "Street Name | \n", "Cross Street 1 | \n", "Cross Street 2 | \n", "Intersection Street 1 | \n", "Intersection Street 2 | \n", "Address Type | \n", "City | \n", "Landmark | \n", "Facility Type | \n", "Status | \n", "Due Date | \n", "Resolution Action Updated Date | \n", "Community Board | \n", "Borough | \n", "X Coordinate (State Plane) | \n", "Y Coordinate (State Plane) | \n", "Park Facility Name | \n", "Park Borough | \n", "School Name | \n", "School Number | \n", "School Region | \n", "School Code | \n", "School Phone Number | \n", "School Address | \n", "School City | \n", "School State | \n", "School Zip | \n", "School Not Found | \n", "School or Citywide Complaint | \n", "Vehicle Type | \n", "Taxi Company Borough | \n", "Taxi Pick Up Location | \n", "Bridge Highway Name | \n", "Bridge Highway Direction | \n", "Road Ramp | \n", "Bridge Highway Segment | \n", "Garage Lot Name | \n", "Ferry Direction | \n", "Ferry Terminal Name | \n", "Latitude | \n", "Longitude | \n", "Location | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "26589651 | \n", "10/31/2013 02:08:41 AM | \n", "NaN | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Street/Sidewalk | \n", "Loud Talking | \n", "Street/Sidewalk | \n", "11432 | \n", "90-03 169 STREET | \n", "169 STREET | \n", "90 AVENUE | \n", "91 AVENUE | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "JAMAICA | \n", "NaN | \n", "Precinct | \n", "Assigned | \n", "10/31/2013 10:08:41 AM | \n", "10/31/2013 02:35:17 AM | \n", "12 QUEENS | \n", "QUEENS | \n", "1042027 | \n", "197389 | \n", "Unspecified | \n", "QUEENS | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.708275 | \n", "-73.791604 | \n", "(40.70827532593202, -73.79160395779721) | \n", "
1 | \n", "26593698 | \n", "10/31/2013 02:01:04 AM | \n", "NaN | \n", "NYPD | \n", "New York City Police Department | \n", "Illegal Parking | \n", "Commercial Overnight Parking | \n", "Street/Sidewalk | \n", "11378 | \n", "58 AVENUE | \n", "58 AVENUE | \n", "58 PLACE | \n", "59 STREET | \n", "NaN | \n", "NaN | \n", "BLOCKFACE | \n", "MASPETH | \n", "NaN | \n", "Precinct | \n", "Open | \n", "10/31/2013 10:01:04 AM | \n", "NaN | \n", "05 QUEENS | \n", "QUEENS | \n", "1009349 | \n", "201984 | \n", "Unspecified | \n", "QUEENS | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.721041 | \n", "-73.909453 | \n", "(40.721040535628305, -73.90945306791765) | \n", "
2 | \n", "26594139 | \n", "10/31/2013 02:00:24 AM | \n", "10/31/2013 02:40:32 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Commercial | \n", "Loud Music/Party | \n", "Club/Bar/Restaurant | \n", "10032 | \n", "4060 BROADWAY | \n", "BROADWAY | \n", "WEST 171 STREET | \n", "WEST 172 STREET | \n", "NaN | \n", "NaN | \n", "ADDRESS | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 10:00:24 AM | \n", "10/31/2013 02:39:42 AM | \n", "12 MANHATTAN | \n", "MANHATTAN | \n", "1001088 | \n", "246531 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.843330 | \n", "-73.939144 | \n", "(40.84332975466513, -73.93914371913482) | \n", "
3 | \n", "26595721 | \n", "10/31/2013 01:56:23 AM | \n", "10/31/2013 02:21:48 AM | \n", "NYPD | \n", "New York City Police Department | \n", "Noise - Vehicle | \n", "Car/Truck Horn | \n", "Street/Sidewalk | \n", "10023 | \n", "WEST 72 STREET | \n", "WEST 72 STREET | \n", "COLUMBUS AVENUE | \n", "AMSTERDAM AVENUE | \n", "NaN | \n", "NaN | \n", "BLOCKFACE | \n", "NEW YORK | \n", "NaN | \n", "Precinct | \n", "Closed | \n", "10/31/2013 09:56:23 AM | \n", "10/31/2013 02:21:10 AM | \n", "07 MANHATTAN | \n", "MANHATTAN | \n", "989730 | \n", "222727 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.778009 | \n", "-73.980213 | \n", "(40.7780087446372, -73.98021349023975) | \n", "
4 | \n", "26590930 | \n", "10/31/2013 01:53:44 AM | \n", "NaN | \n", "DOHMH | \n", "Department of Health and Mental Hygiene | \n", "Rodent | \n", "Condition Attracting Rodents | \n", "Vacant Lot | \n", "10027 | \n", "WEST 124 STREET | \n", "WEST 124 STREET | \n", "LENOX AVENUE | \n", "ADAM CLAYTON POWELL JR BOULEVARD | \n", "NaN | \n", "NaN | \n", "BLOCKFACE | \n", "NEW YORK | \n", "NaN | \n", "NaN | \n", "Pending | \n", "11/30/2013 01:53:44 AM | \n", "10/31/2013 01:59:54 AM | \n", "10 MANHATTAN | \n", "MANHATTAN | \n", "998815 | \n", "233545 | \n", "Unspecified | \n", "MANHATTAN | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "Unspecified | \n", "N | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "40.807691 | \n", "-73.947387 | \n", "(40.80769092704951, -73.94738703491433) | \n", "
5 rows × 52 columns
\n", "\n", " | Complaint Type | \n", "Borough | \n", "
---|---|---|
0 | \n", "Noise - Street/Sidewalk | \n", "QUEENS | \n", "
1 | \n", "Illegal Parking | \n", "QUEENS | \n", "
2 | \n", "Noise - Commercial | \n", "MANHATTAN | \n", "
3 | \n", "Noise - Vehicle | \n", "MANHATTAN | \n", "
4 | \n", "Rodent | \n", "MANHATTAN | \n", "
5 | \n", "Noise - Commercial | \n", "QUEENS | \n", "
6 | \n", "Blocked Driveway | \n", "QUEENS | \n", "
7 | \n", "Noise - Commercial | \n", "QUEENS | \n", "
8 | \n", "Noise - Commercial | \n", "MANHATTAN | \n", "
9 | \n", "Noise - Commercial | \n", "BROOKLYN | \n", "
10 | \n", "Noise - House of Worship | \n", "BROOKLYN | \n", "
11 | \n", "Noise - Commercial | \n", "MANHATTAN | \n", "
12 | \n", "Illegal Parking | \n", "MANHATTAN | \n", "
13 | \n", "Noise - Vehicle | \n", "BRONX | \n", "
14 | \n", "Rodent | \n", "BROOKLYN | \n", "
15 | \n", "Noise - House of Worship | \n", "MANHATTAN | \n", "
16 | \n", "Noise - Street/Sidewalk | \n", "STATEN ISLAND | \n", "
17 | \n", "Illegal Parking | \n", "BROOKLYN | \n", "
18 | \n", "Street Light Condition | \n", "BROOKLYN | \n", "
19 | \n", "Noise - Commercial | \n", "MANHATTAN | \n", "
20 | \n", "Noise - House of Worship | \n", "BROOKLYN | \n", "
21 | \n", "Noise - Commercial | \n", "MANHATTAN | \n", "
22 | \n", "Noise - Vehicle | \n", "QUEENS | \n", "
23 | \n", "Noise - Commercial | \n", "BROOKLYN | \n", "
24 | \n", "Blocked Driveway | \n", "STATEN ISLAND | \n", "
25 | \n", "Noise - Street/Sidewalk | \n", "STATEN ISLAND | \n", "
26 | \n", "Street Light Condition | \n", "BROOKLYN | \n", "
27 | \n", "Harboring Bees/Wasps | \n", "MANHATTAN | \n", "
28 | \n", "Noise - Street/Sidewalk | \n", "MANHATTAN | \n", "
29 | \n", "Street Light Condition | \n", "STATEN ISLAND | \n", "
30 | \n", "Blocked Driveway | \n", "STATEN ISLAND | \n", "
31 | \n", "Noise - Street/Sidewalk | \n", "BROOKLYN | \n", "
32 | \n", "Taxi Complaint | \n", "MANHATTAN | \n", "
33 | \n", "Noise - House of Worship | \n", "MANHATTAN | \n", "
34 | \n", "Homeless Encampment | \n", "MANHATTAN | \n", "
35 | \n", "Blocked Driveway | \n", "QUEENS | \n", "
36 | \n", "Traffic Signal Condition | \n", "BROOKLYN | \n", "
37 | \n", "Noise - Commercial | \n", "BROOKLYN | \n", "
38 | \n", "Traffic Signal Condition | \n", "BROOKLYN | \n", "
39 | \n", "Blocked Driveway | \n", "QUEENS | \n", "
40 | \n", "Noise - Commercial | \n", "QUEENS | \n", "
41 | \n", "Food Establishment | \n", "MANHATTAN | \n", "
42 | \n", "Noise - Commercial | \n", "BROOKLYN | \n", "
43 | \n", "Noise - Commercial | \n", "BROOKLYN | \n", "
44 | \n", "Noise - Park | \n", "BRONX | \n", "
45 | \n", "Noise - Street/Sidewalk | \n", "BRONX | \n", "
46 | \n", "Noise - Commercial | \n", "BRONX | \n", "
47 | \n", "Taxi Complaint | \n", "MANHATTAN | \n", "
48 | \n", "Noise - Commercial | \n", "MANHATTAN | \n", "
49 | \n", "Noise - Street/Sidewalk | \n", "BROOKLYN | \n", "
50 | \n", "Noise - Commercial | \n", "MANHATTAN | \n", "
51 | \n", "Broken Muni Meter | \n", "MANHATTAN | \n", "
52 | \n", "Blocked Driveway | \n", "BROOKLYN | \n", "
53 | \n", "Noise - Commercial | \n", "MANHATTAN | \n", "
54 | \n", "Benefit Card Replacement | \n", "Unspecified | \n", "
55 | \n", "Noise - Commercial | \n", "MANHATTAN | \n", "
56 | \n", "Sanitation Condition | \n", "BROOKLYN | \n", "
57 | \n", "ELECTRIC | \n", "BROOKLYN | \n", "
58 | \n", "PLUMBING | \n", "BROOKLYN | \n", "
59 | \n", "HEATING | \n", "BRONX | \n", "
\n", " | ... | \n", "... | \n", "
111069 rows × 2 columns
\n", "\n", " | Complaint Type | \n", "Borough | \n", "
---|---|---|
0 | \n", "Noise - Street/Sidewalk | \n", "QUEENS | \n", "
1 | \n", "Illegal Parking | \n", "QUEENS | \n", "
2 | \n", "Noise - Commercial | \n", "MANHATTAN | \n", "
3 | \n", "Noise - Vehicle | \n", "MANHATTAN | \n", "
4 | \n", "Rodent | \n", "MANHATTAN | \n", "
5 | \n", "Noise - Commercial | \n", "QUEENS | \n", "
6 | \n", "Blocked Driveway | \n", "QUEENS | \n", "
7 | \n", "Noise - Commercial | \n", "QUEENS | \n", "
8 | \n", "Noise - Commercial | \n", "MANHATTAN | \n", "
9 | \n", "Noise - Commercial | \n", "BROOKLYN | \n", "
10 rows × 2 columns
\n", "